This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Power BI Report Server and the Power BI service have many similarities and some key differences. This table explains which is which.
| Features | Power BI Report Server | Power BI Service | Notes |
|---|---|---|---|
| Analyze in Excel | No | Yes | Analyze in Excel |
| Bookmarks | No | Yes | Bookmarks in the Power BI service |
| Deployment | On-premises or hosted cloud | Cloud | Power BI Report Server can be deployed in Azure VMs (hosted cloud) if licensed through Power BI Premium or SQL Server Enterprise with Software Assurance |
| Data sources | Cloud and/or on-premises | Cloud and/or on-premises | |
| License | Power BI Premium or SQL Server EE with Software Assurance (SA) | Power BI Pro and/or Power BI Premium | |
| Lifecycle | Modern lifecycle policy | Fully managed service | |
| Release cycle | Three times a year (January, May, September) | Once a month | Latest features and fixes come to the Power BI service first. A rollup of features from Power BI Desktop releases for the service comes to Power BI Report Server in each release; most other features are only meant for the Power BI service. |
| Composite models | No | Yes | |
| Connect to services like Salesforce | Yes | Yes | Connect to the services you use with template apps in the Power BI service. In Power BI Report Server, use certified connectors to connect to services. See Power BI report data sources in Power BI Report Server for details. |
| Create Power BI reports in Power BI Desktop | Yes | Yes | |
| Create Power BI reports in the browser | No | Yes | |
| Dashboards | No | Yes | Dashboards in the Power BI service |
| Distribute group of reports using apps | No | Yes | Create and publish apps with dashboards and reports |
| Dynamic M Query Parameters | No | Yes | |
| Export to Power Point (PPTX) | No | Yes | Export data for visuals to CSV or Excel options are available in Report Server. |
| Gateway required | No | Yes for on-premises data sources | |
| Host and connect to Power BI shared datasets | No | Yes | Intro to datasets across workspaces |
| Q&A | No | Yes | Q&A in the Power BI service and Power BI Desktop |
| Quick insights | No | Yes | Automatically generate data insights with Power BI |
| Paginated reports | Yes | Yes | Paginated reports |
| Personalize visuals | No | Yes | Consumers can customize visual type or data fields without modifying the report itself. |
| Power BI mobile apps | Yes | Yes | Power BI mobile apps overview |
| Real-time streaming | No | Yes | Real-time streaming in Power BI |
| Automatic page refresh for DirectQuery models | No | Yes | Automatic page refresh |
| ArcGIS for Power BI | Yes | Yes | ArcGIS for Power BI |
| Email subscriptions for Power BI reports | No | Yes | Subscribe yourself or others to a report or dashboard in the Power BI service |
| Email subscriptions for paginated reports | Yes | Yes | Subscribe yourself and others to paginated reports in the Power BI service Email delivery in Reporting Services |
| Data alerts | No | Yes | Data alerts in the Power BI service |
| Row-level security (RLS) | Yes | Yes | Available in both DirectQuery (data source) & Import mode Row-level security in the Power BI service Row-level security in Power BI Report Server |
| Many-to-many relationships | Yes | Yes | Apply many-to-many relationships in Power BI Desktop |
| Cross-report drillthrough | No | Yes | Use cross-report drillthrough |
| Full-screen mode | Yes | Yes | Full-screen mode in the Power BI service |
| R scripts and visuals | No | Yes | Create R visuals and run R scripts in Power BI Desktop and publish them to the Power BI service. You can't save Power BI reports with R scripts or visuals to Power BI Report Server. |
| Python scripts and visuals | No | Yes | Create Python scripts and visuals in Power BI Desktop and publish them to the Power BI service. You can't save Power BI reports with Python scripts or visuals to Power BI Report Server. |
| Preview features | No | Yes | |
| Power BI visuals | Yes | Yes | Power BI visuals |
| Power BI Desktop | Version optimized for Report Server, available for download with Report Server | Version optimized for Power BI Service, available from the Windows Store | Power BI Desktop for the report server Power BI Desktop for the Power BI service |
| Data Privacy Levels | No | Yes | Data Privacy Levels are available for reports in the Power BI service. In Power BI Report Server, use Role definitions. |
| Sensitivity Labels | No | Yes | Sensitivity Labels |
| Template apps | No | Yes | Install and distribute template apps in your organization |
These considerations and limitations apply to Power BI Report Server.
The following Power BI service features are not supported within Power BI Report Server:
Training
Module
Publish and access reports in Power BI service – Online workshop - Training
Learn how to use Power BI to create a mobile view, publish a report, build a dashboard, and use storytelling with Power BI within PowerPoint.
Certification
Microsoft Certified: Power BI Data Analyst Associate - Certifications
Demonstrate methods and best practices that align with business and technical requirements for modeling, visualizing, and analyzing data with Microsoft Power BI.
Documentation
What is Power BI Report Server? - Power BI
Get an overview of Power BI Report Server to understand how it fits in with SQL Server Reporting Services (SSRS) and the rest of Power BI.
Create a Power BI report for Power BI Report Server - Power BI
Learn how to create a Power BI report for Power BI Report Server in a few simple steps.
Capacity planning guidance for Power BI Report Server - Power BI
This paper offers guidance on capacity planning for Power BI Report Server by sharing results of load test executions of various workloads.